# Prerequisites

This topic list the prerequisites for using the SAP Sybase ASE source endpoint in a replication task.

## General prerequisites

* SAP Sybase ASE replication enabled for tables using the `sp_setreptable` command or privileges to enable it automatically.

* `RepAgent` must be disabled on the SAP Sybase ASE database.

* When replicating to SAP Sybase ASE 15.7 installed on a Windows machine configured with a non-Latin language (e.g. Chinese), Qlik Replicate requires Sybase 15.7 SP121 to be installed on the SAP Sybase ASE machine.

* Turn off automatic truncation by running the following command:

  `sp_dboption mydb, "trunc log on chkpt", false`

  `go`

## Replicate on Windows

Install SAP Adaptive Server Enterprise ODBC Driver 16.0 (64-bit) on the Qlik Replicate computer.

## Replicate on Linux

1. Stop the Replicate service and optionally confirm that it has stopped as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

2. Install SAP Adaptive Server Enterprise ODBC Driver 16.0 (64-bit) on the Qlik Replicate computer.

3. After the driver is installed, verify that the /etc/odbcinst.ini file contains an entry for Sybase, as in the following example:

   ```
   [Adaptive Server Enterprise]    
   Description=Sybase ODBC Driver
   Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so    
   Setup=    
   FileUsage=-1    
   CPTimeout=    
   CPReuse=
   ```

4. Start the Replicate service and optionally confirm that it has started as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

5. Verify that the symbolic link refers to libsybdrvodb-sqllen8.so.

   In the event that it does not, redirect the symbolic link to libsybdrvodb-sqllen8.so by running the following command:

   `ln -fs ./libsybdrvodb-sqllen8.so libsybdrvodb.so`